%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left

    subgraph "Buckets for queries/v4/nested_arrays.select"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: 9, 10, 28, 11<br />2: PgSelect[8]<br />3: Connection[12]<br />4: ConnectionItems[14]"):::bucket
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 12, 14, 11, 28<br /><br />ROOT Connectionᐸ8ᐳ[12]"):::bucket
    Bucket3("Bucket 3 (listItem)<br />Deps: 11, 28<br /><br />ROOT __Item{3}ᐸ14ᐳ[17]"):::bucket
    Bucket4("Bucket 4 (nullableBoundary)<br />Deps: 18, 11, 28<br /><br />ROOT PgSelectSingle{3}ᐸtᐳ[18]"):::bucket
    Bucket6("Bucket 6 (listItem)<br />Deps: 11, 28<br /><br />ROOT __Item{6}ᐸ20ᐳ[23]<br />1: PgSelect[24]<br />2: PgSelectRows[29]"):::bucket
    Bucket7("Bucket 7 (listItem)<br /><br />ROOT __Item{7}ᐸ29ᐳ[30]"):::bucket
    end
    Bucket0 --> Bucket1
    Bucket1 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket6
    Bucket6 --> Bucket7

    %% plan dependencies
    Object11{{"Object[11∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ<br />Dependents: 2"}}:::plan
    Access9{{"Access[9∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access10{{"Access[10∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access9 & Access10 --> Object11
    PgSelect8[["PgSelect[8∈0] ➊<br />ᐸtᐳ<br />More deps:<br />- Object[11]"]]:::plan
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access9
    __Value2 --> Access10
    Connection12[["Connection[12∈0] ➊<br />ᐸ8ᐳ"]]:::plan
    PgSelect8 --> Connection12
    ConnectionItems14[["ConnectionItems[14∈0] ➊"]]:::plan
    Connection12 --> ConnectionItems14
    PgFromExpression28{{"PgFromExpression[28∈0] ➊"}}:::plan
    __Item17[/"__Item[17∈3]<br />ᐸ14ᐳ"\]:::itemplan
    ConnectionItems14 ==> __Item17
    PgSelectSingle18{{"PgSelectSingle[18∈3]<br />ᐸtᐳ"}}:::plan
    __Item17 --> PgSelectSingle18
    PgClassExpression19{{"PgClassExpression[19∈4]<br />ᐸ__t__.”k”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression19
    PgClassExpression20{{"PgClassExpression[20∈4]<br />ᐸ__t__.”v”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression20
    PgSelect24[["PgSelect[24∈6]<br />ᐸfrmcdc_workHourᐳ<br />More deps:<br />- Object[11]"]]:::plan
    __Item23[/"__Item[23∈6]<br />ᐸ20ᐳ"\]:::itemplan
    __Item23 & PgFromExpression28 --> PgSelect24
    PgClassExpression20 ==> __Item23
    PgSelectRows29[["PgSelectRows[29∈6]"]]:::plan
    PgSelect24 --> PgSelectRows29
    __Item30[/"__Item[30∈7]<br />ᐸ29ᐳ"\]:::itemplan
    PgSelectRows29 ==> __Item30
    PgSelectSingle31{{"PgSelectSingle[31∈7]<br />ᐸfrmcdc_workHourᐳ"}}:::plan
    __Item30 --> PgSelectSingle31
    PgClassExpression32{{"PgClassExpression[32∈7]<br />ᐸ__frmcdc_w...rom_hours”ᐳ"}}:::plan
    PgSelectSingle31 --> PgClassExpression32
    PgClassExpression33{{"PgClassExpression[33∈7]<br />ᐸ__frmcdc_w...m_minutes”ᐳ"}}:::plan
    PgClassExpression32 o--o PgClassExpression33
    PgClassExpression34{{"PgClassExpression[34∈7]<br />ᐸ__frmcdc_w...”to_hours”ᐳ"}}:::plan
    PgClassExpression33 o--o PgClassExpression34
    PgClassExpression35{{"PgClassExpression[35∈7]<br />ᐸ__frmcdc_w...o_minutes”ᐳ"}}:::plan
    PgClassExpression34 o--o PgClassExpression35

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,PgSelect8,Access9,Access10,Object11,Connection12,ConnectionItems14,PgFromExpression28 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1 bucket1
    classDef bucket3 stroke:#ffa500
    class Bucket3,__Item17,PgSelectSingle18 bucket3
    classDef bucket4 stroke:#0000ff
    class Bucket4,PgClassExpression19,PgClassExpression20 bucket4
    classDef bucket6 stroke:#ff1493
    class Bucket6,__Item23,PgSelect24,PgSelectRows29 bucket6
    classDef bucket7 stroke:#808000
    class Bucket7,__Item30,PgSelectSingle31,PgClassExpression32,PgClassExpression33,PgClassExpression34,PgClassExpression35 bucket7

